SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE [dbo].[usp_UpdateRecruitment]
	
	(
	@param_id int,
	@param_topic NVarChar(100),
	@param_contents text,
	@param_type NVarChar(50),
	@param_start_time smalldatetime,
	@param_end_time smalldatetime,
	@param_place NVarChar(50),
	@param_organisers NVarChar(50),
	@param_undertakingside NVarChar(50),
	@param_update_time smalldatetime,
	@param_user_update NVarChar(50),
	@param_state Bit
	)
	
AS
	/* SET NOCOUNT ON */
	update dbo.JOL_Recruitment 
	Set
	topic=@param_topic,
	contents=@param_contents,
	type=@param_type,
	start_time=@param_start_time,
	end_time=@param_end_time,
	place=@param_place,
	organisers=@param_organisers,
	undertakingside=@param_undertakingside,
	update_time=@param_update_time,
	user_update=@param_user_update,
	state=@param_state
	where
	id= @param_id
	
	RETURN
GO
